| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
FaFAFSA12ID |
|
INTEGER |
NO |
|
SyStudentID |
|
INTEGER |
NO |
|
FaStudentPellID |
|
INTEGER |
YES |
|
| Status |
|
CHAR(1) |
YES |
|
| DateTran |
|
DATETIME |
YES |
|
| BatchID |
|
CHAR(23) |
YES |
|
| CPSStatus |
|
CHAR(1) |
YES |
|
| LastName |
|
CHAR(16) |
YES |
|
| FirstName |
|
CHAR(12) |
YES |
|
| MI |
|
CHAR(1) |
YES |
|
| Address |
|
CHAR(35) |
YES |
|
| City |
|
CHAR(16) |
YES |
|
| State |
|
CHAR(2) |
YES |
|
| Zip |
|
CHAR(5) |
YES |
|
| SSN |
|
CHAR(9) |
YES |
|
| DOB |
|
DATETIME |
YES |
|
| StudentPhone |
|
CHAR(10) |
YES |
|
| StudentDLNumber |
|
CHAR(20) |
YES |
|
| StudentDLState |
|
CHAR(2) |
YES |
|
| StudentEmail |
|
CHAR(50) |
YES |
|
| Citizen |
|
CHAR(1) |
YES |
|
| AlienNumber |
|
CHAR(9) |
YES |
|
| StudentMaritalStatus |
|
CHAR(1) |
YES |
|
| StudentMaritalStatusDate |
|
DATETIME |
YES |
|
| StudentLegState |
|
CHAR(2) |
YES |
|
| StudentLegResBef |
|
CHAR(1) |
YES |
|
| StudentLegResDate |
|
CHAR(7) |
YES |
|
| Male |
|
CHAR(1) |
YES |
|
| SelServiceReg |
|
CHAR(1) |
YES |
|
| DrugConvictElig |
|
CHAR(1) |
YES |
|
| FatherHighGrade |
|
CHAR(1) |
YES |
|
| MotherHighGrade |
|
CHAR(1) |
YES |
|
| HSGedReceived |
|
CHAR(1) |
YES |
|
| HighSchoolName |
|
CHAR(50) |
YES |
|
| HighSchoolCity |
|
CHAR(28) |
YES |
|
| HighSchoolState |
|
CHAR(2) |
YES |
|
| FirstBachDegree |
|
CHAR(1) |
YES |
|
| YearCollege |
|
CHAR(1) |
YES |
|
| Degree |
|
CHAR(1) |
YES |
|
| InterestedInAid |
|
CHAR(1) |
YES |
|
| StudentTaxFiled |
|
CHAR(1) |
YES |
|
| StudentTaxFormType |
|
CHAR(1) |
YES |
|
| StudentElig1040 |
|
CHAR(1) |
YES |
|
| StudentGross |
|
DECIMAL(18, 0) |
YES |
|
| StudentIncomeTax |
|
DECIMAL(18, 0) |
YES |
|
| StudentExemptions |
|
CHAR(2) |
YES |
|
| StudentIncome |
|
DECIMAL(18, 0) |
YES |
|
| SpouseIncome |
|
DECIMAL(18, 0) |
YES |
|
| StudentCash |
|
DECIMAL(18, 0) |
YES |
|
| StudentInvestment |
|
DECIMAL(18, 0) |
YES |
|
| StudentBusiness |
|
DECIMAL(18, 0) |
YES |
|
| StudEducationCredits |
|
DECIMAL(18, 0) |
YES |
|
| StudChildSupportPaid |
|
DECIMAL(18, 0) |
YES |
|
| StudNeedBasedEmployment |
|
DECIMAL(18, 0) |
YES |
|
| StudGrantAid |
|
DECIMAL(18, 0) |
YES |
|
| StudCombatPay |
|
DECIMAL(18, 0) |
YES |
|
| StudCoOpEarning |
|
DECIMAL(18, 0) |
YES |
|
| StudPensionPayments |
|
DECIMAL(18, 0) |
YES |
|
| StudIRAPayments |
|
DECIMAL(18, 0) |
YES |
|
| StudChildSupportReceive |
|
DECIMAL(18, 0) |
YES |
|
| StudInterestIncome |
|
DECIMAL(18, 0) |
YES |
|
| StudIRADistributions |
|
DECIMAL(18, 0) |
YES |
|
| StudUntaxedPension |
|
DECIMAL(18, 0) |
YES |
|
| StudMilitaryAllowance |
|
DECIMAL(18, 0) |
YES |
|
| StudVetNonEducationBenefits |
|
DECIMAL(18, 0) |
YES |
|
| StudOtherUnTaxedIncome |
|
DECIMAL(18, 0) |
YES |
|
| StudOtherNonReportedMoneyReceived |
|
DECIMAL(18, 0) |
YES |
|
| BornBefore |
|
CHAR(1) |
YES |
|
| StudentMarried |
|
CHAR(1) |
YES |
|
| DegreeBeyond |
|
CHAR(1) |
YES |
|
| ActiveDutyMilitary |
|
CHAR(1) |
YES |
|
| Veteran |
|
CHAR(1) |
YES |
|
| Children |
|
CHAR(1) |
YES |
|
| LegalDependents |
|
CHAR(1) |
YES |
|
| Orphan |
|
CHAR(1) |
YES |
|
| EmancipatedMinor |
|
CHAR(1) |
YES |
|
| LegalGuardianShip |
|
CHAR(1) |
YES |
|
| HomelessYouthBySchool |
|
CHAR(1) |
YES |
|
| HomelessYouthByHud |
|
CHAR(1) |
YES |
|
| AtRiskHomelessness |
|
CHAR(1) |
YES |
|
| ParentMaritalStatus |
|
CHAR(1) |
YES |
|
| ParentMaritalStatusDate |
|
CHAR(7) |
YES |
|
| FatherSSN |
|
CHAR(9) |
YES |
|
| FatherLastName |
|
CHAR(16) |
YES |
|
| FatherFInitial |
|
CHAR(1) |
YES |
|
| FatherDOB |
|
DATETIME |
YES |
|
| MotherSSN |
|
CHAR(9) |
YES |
|
| MotherLastName |
|
CHAR(16) |
YES |
|
| MotherFInitial |
|
CHAR(1) |
YES |
|
| MotherDOB |
|
DATETIME |
YES |
|
| ParentEmail |
|
CHAR(50) |
YES |
|
| ParentLegState |
|
CHAR(2) |
YES |
|
| ParentLegResBef |
|
CHAR(2) |
YES |
|
| ParentLegResDate |
|
CHAR(7) |
YES |
|
| ParentNumFamily |
|
CHAR(2) |
YES |
|
| ParentNumCollege |
|
CHAR(1) |
YES |
|
| ParentSSIBenefits |
|
CHAR(1) |
YES |
|
| ParentFoodStamps |
|
CHAR(1) |
YES |
|
| ParentFreeLunch |
|
CHAR(1) |
YES |
|
| ParentTANFBenefits |
|
CHAR(1) |
YES |
|
| ParentWICBenefits |
|
CHAR(1) |
YES |
|
| ParentTaxFiled |
|
CHAR(1) |
YES |
|
| ParentTaxFormType |
|
CHAR(1) |
YES |
|
| ParentElig1040 |
|
CHAR(1) |
YES |
|
| ParentDislocatedWorker |
|
CHAR(1) |
YES |
|
| ParentGross |
|
DECIMAL(18, 0) |
YES |
|
| ParentIncomeTax |
|
DECIMAL(18, 0) |
YES |
|
| ParentExemptions |
|
CHAR(2) |
YES |
|
| FatherIncome |
|
DECIMAL(18, 0) |
YES |
|
| MotherIncome |
|
DECIMAL(18, 0) |
YES |
|
| ParentCash |
|
DECIMAL(18, 0) |
YES |
|
| ParentInvestment |
|
DECIMAL(18, 0) |
YES |
|
| ParentBusiness |
|
DECIMAL(18, 0) |
YES |
|
| ParentEducationCredits |
|
DECIMAL(18, 0) |
YES |
|
| ParentChildSupportPaid |
|
DECIMAL(18, 0) |
YES |
|
| ParentNeedBasedEmployment |
|
DECIMAL(18, 0) |
YES |
|
| ParentGrantAid |
|
DECIMAL(18, 0) |
YES |
|
| ParentCombatPay |
|
DECIMAL(18, 0) |
YES |
|
| ParentCoOpEarning |
|
DECIMAL(18, 0) |
YES |
|
| ParentPensionPayments |
|
DECIMAL(18, 0) |
YES |
|
| ParentIRAPayments |
|
DECIMAL(18, 0) |
YES |
|
| ParentChildSupportReceive |
|
DECIMAL(18, 0) |
YES |
|
| ParentInterestIncome |
|
DECIMAL(18, 0) |
YES |
|
| ParentIRADistributions |
|
DECIMAL(18, 0) |
YES |
|
| ParentUntaxedPension |
|
DECIMAL(18, 0) |
YES |
|
| ParentMilitaryAllowance |
|
DECIMAL(18, 0) |
YES |
|
| ParentVetNonEducationBenefits |
|
DECIMAL(18, 0) |
YES |
|
| ParentOtherUnTaxedIncome |
|
DECIMAL(18, 0) |
YES |
|
| StudentNumFamily |
|
CHAR(2) |
YES |
|
| StudentNumCollege |
|
CHAR(1) |
YES |
|
| StudentSSIBenefits |
|
CHAR(1) |
YES |
|
| StudentFoodStamps |
|
CHAR(1) |
YES |
|
| StudentFreeLunch |
|
CHAR(1) |
YES |
|
| StudentTANFBenefits |
|
CHAR(1) |
YES |
|
| StudentWICBenefits |
|
CHAR(1) |
YES |
|
| StudentDislocatedWorker |
|
CHAR(1) |
YES |
|
| FirstCollegeChoice |
|
CHAR(6) |
YES |
|
| FirstCollegeHousing |
|
CHAR(1) |
YES |
|
| SecondCollegeChoice |
|
CHAR(6) |
YES |
|
| SecondCollegeHousing |
|
CHAR(1) |
YES |
|
| ThirdCollegeChoice |
|
CHAR(6) |
YES |
|
| ThirdCollegeHousing |
|
CHAR(1) |
YES |
|
| FourthCollegeChoice |
|
CHAR(6) |
YES |
|
| FourthCollegeHousing |
|
CHAR(1) |
YES |
|
| FifthCollegeChoice |
|
CHAR(6) |
YES |
|
| FifthCollegeHousing |
|
CHAR(1) |
YES |
|
| SixthCollegeChoice |
|
CHAR(6) |
YES |
|
| SixthCollegeHousing |
|
CHAR(1) |
YES |
|
| SeventhCollegeChoice |
|
CHAR(6) |
YES |
|
| SeventhCollegeHousing |
|
CHAR(1) |
YES |
|
| EighthCollegeChoice |
|
CHAR(6) |
YES |
|
| EighthCollegeHousing |
|
CHAR(1) |
YES |
|
| NinethCollegeChoice |
|
CHAR(6) |
YES |
|
| NinethCollegeHousing |
|
CHAR(1) |
YES |
|
| TenthCollegeChoice |
|
CHAR(6) |
YES |
|
| TenthCollegeHousing |
|
CHAR(1) |
YES |
|
| DateCompleted |
|
DATETIME |
YES |
|
| SignedByFlag |
|
CHAR(1) |
YES |
|
| PreparerSSN |
|
CHAR(9) |
YES |
|
| PreparerEIN |
|
CHAR(9) |
YES |
|
| PreparerSignature |
|
CHAR(1) |
YES |
|
| FirstCollegeName |
|
CHAR(30) |
YES |
|
| FirstCollegeAddress |
|
CHAR(60) |
YES |
|
| FirstCollegeState |
|
CHAR(2) |
YES |
|
| SecondCollegeName |
|
CHAR(30) |
YES |
|
| SecondCollegeAddress |
|
CHAR(60) |
YES |
|
| SecondCollegeState |
|
CHAR(2) |
YES |
|
| ThirdCollegeName |
|
CHAR(30) |
YES |
|
| ThirdCollegeAddress |
|
CHAR(60) |
YES |
|
| ThirdCollegeState |
|
CHAR(2) |
YES |
|
| FourthCollegeName |
|
CHAR(30) |
YES |
|
| FourthCollegeAddress |
|
CHAR(60) |
YES |
|
| FourthCollegeState |
|
CHAR(2) |
YES |
|
| FifthCollegeName |
|
CHAR(30) |
YES |
|
| FifthCollegeAddress |
|
CHAR(60) |
YES |
|
| FifthCollegeState |
|
CHAR(2) |
YES |
|
| SixthCollegeName |
|
CHAR(30) |
YES |
|
| SixthCollegeAddress |
|
CHAR(60) |
YES |
|
| SixthCollegeState |
|
CHAR(2) |
YES |
|
| SeventhCollegeName |
|
CHAR(30) |
YES |
|
| SeventhCollegeAddress |
|
CHAR(60) |
YES |
|
| SeventhCollegeState |
|
CHAR(2) |
YES |
|
| EighthCollegeName |
|
CHAR(30) |
YES |
|
| EighthCollegeAddress |
|
CHAR(60) |
YES |
|
| EighthCollegeState |
|
CHAR(2) |
YES |
|
| NinethCollegeName |
|
CHAR(30) |
YES |
|
| NinethCollegeAddress |
|
CHAR(60) |
YES |
|
| NinethCollegeState |
|
CHAR(2) |
YES |
|
| TenthCollegeName |
|
CHAR(30) |
YES |
|
| TenthCollegeAddress |
|
CHAR(60) |
YES |
|
| TenthCollegeState |
|
CHAR(2) |
YES |
|
| StudentAmountWSA |
|
DECIMAL(18, 0) |
YES |
|
| StudentAmountWSB |
|
DECIMAL(18, 0) |
YES |
|
| ParentAmountWSA |
|
DECIMAL(18, 0) |
YES |
|
| ParentAmountWSB |
|
DECIMAL(18, 0) |
YES |
|
| OrigParentNumCollege |
|
DECIMAL(1, 0) |
YES |
|
| OrigParentGross |
|
DECIMAL(7, 0) |
YES |
|
| OrigParentAmountWSA |
|
DECIMAL(18, 0) |
YES |
|
| OrigStudentNumCollege |
|
DECIMAL(1, 0) |
YES |
|
| OrigStudentGross |
|
DECIMAL(7, 0) |
YES |
|
| OrigStudentAmountWSA |
|
DECIMAL(18, 0) |
YES |
|
| FaBatchID |
|
CHAR(26) |
YES |
|
| ReceiptDate |
|
DATETIME |
YES |
|
| ModFlag |
|
CHAR(1) |
NO |
|
UserID |
|
INTEGER |
NO |
|
| DateAdded |
|
DATETIME |
NO |
|
| DateLstMod |
|
DATETIME |
NO |
|
| ts |
|
TIMESTAMP/DATE |
NO |
|